namespace WorkerRole1.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class InitialCreate : DbMigration
    {
        public override void Up()
        {
            CreateTable(
                "dbo.PageViewPerformances",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        url = c.String(),
                        urlData_port = c.Int(nullable: false),
                        urlData_protocol = c.String(),
                        urlData_host = c.String(),
                        urlData_base = c.String(),
                        urlData_hashTag = c.String(),
                        total_value = c.Double(nullable: false),
                        networkConnection_value = c.Double(nullable: false),
                        sendRequest_value = c.Double(nullable: false),
                        receiveRequest_value = c.Double(nullable: false),
                        clientProcess_value = c.Double(nullable: false),
                        name = c.String(),
                        internal_data_id = c.String(),
                        internal_data_documentVersion = c.String(),
                        context_data_eventTime = c.DateTime(nullable: false),
                        context_device_id = c.String(),
                        context_device_type = c.String(),
                        context_device_os = c.String(),
                        context_device_osVersion = c.String(),
                        context_device_locale = c.String(),
                        context_device_userAgent = c.String(),
                        context_device_browser = c.String(),
                        context_device_browserVersion = c.String(),
                        context_device_screenResolution_value = c.String(),
                        context_user_anonId = c.String(),
                        context_user_anonAcquisitionDate = c.String(),
                        context_user_authAcquisitionDate = c.String(),
                        context_user_accountAcquisitionDate = c.String(),
                        context_session_id = c.String(),
                        context_session_isFirst = c.Boolean(nullable: false),
                        context_operation_id = c.String(),
                        context_location_point_lat = c.Double(nullable: false),
                        context_location_point_lon = c.Double(nullable: false),
                        context_location_clientip = c.String(),
                        context_location_continent = c.String(),
                        context_location_country = c.String(),
                        context_location_province = c.String(),
                        context_location_city = c.String(),
                    })
                .PrimaryKey(t => t.Id);
            
        }
        
        public override void Down()
        {
            DropTable("dbo.PageViewPerformances");
        }
    }
}
